package com.ruoyi.system.mapper.HUAWEI;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.system.domain.HUAWEI.EmsBarcodeAttribute;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * @author GE-LV5
 * @create 2023/4/10 16:54
 */
public interface EmsBarcodeAttributeMapper extends BaseMapper<EmsBarcodeAttribute> {
    @Select("select ISNULL(count(*),0) sumTaskNo FROM EMS_BARCODE_ATTRIBUTE t where t.po = #{taskTon} and t.item_number=#{productCode}\n" +
            "GROUP BY t.po,t.item_number")
    Integer selectByTaskTon(@Param("taskTon") String taskTon, @Param("productCode") String productCode);
}
